select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (b.cnpropertyname like '%Old House in Xinle Road%' or b.enpropertyname like '%Old House in Xinle Road%') order by updateTime Desc, a.dftpic desc
High rise Building with elevator, Heritage apt in the Xinle Road, nice with large size terrace, high quality equipements, floor heating system installed
Next to Xiangyang garden，very close to Huanmao Parkson.It's in the heart of french concession,delicate decoration Loft lane house ,full furnished with individua...
